#ifndef OEEXCELWRITER_H
#define OEEXCELWRITER_H

#include "auditxls_global.h"

#include <QString>

class OEExcelWriterPrivate;

class AUDITXLSSHARED_EXPORT OEExcelWriter
{
public:
    OEExcelWriter();

    void CreateWorkSheet(const std::string& SheetName); //创建表格
    void SaveExcelFile(const std::string& FileName);  //保存工作簿
    void SetCellNumber(int row,int col,int number); //设置序号
    void SetCellText(int row,int col,const std::string & text,bool setFont); //设置文本信息
    void SetCellText(int row,int col,const std::wstring & text,bool setFont); //设置文本信息

    void SetCellSize(int row,int col,int row_width ,int col_hight); //设置单元格大小
    void SetCellCenter(); //设置单元格格式居中
    void SetCellLeft(); //设置单元格格式靠左居中
    void MergeCells(int begin_row,int begin_col,int end_row,int end_col);  //合闭单元格

private:
    OEExcelWriterPrivate * const d_ptr;

    Q_DECLARE_PRIVATE(OEExcelWriter)
    Q_DISABLE_COPY(OEExcelWriter)

};

#endif // OEEXCELWRITER_H
